CREATE VIEW [fin].[eod_symbols_v]
AS
SELECT	  sym_id		AS syv_id
		, sym_cd		AS syv_cd
		, sym_desc		AS syv_desc
		, exc_id		AS syv_exc_id
		, exc_cd		AS syv_exc_cd
		, exc_desc		AS syv_exc_desc
		, cnt_id		AS syv_cnt_id
		, cnt_cd		AS syv_cnt_cd
		, cnt_desc		AS syv_cnt_desc
		, cur_id		AS syv_cur_id
		, cur_cd		AS syv_cur_cd
		, cur_desc		AS syv_cur_desc
FROM	fin.eod_symbols
		INNER JOIN fin.eod_exchanges	ON (sym_exc_id = exc_id)
		INNER JOIN fin.com_countries	ON (exc_cnt_id = cnt_id)
		INNER JOIN fin.com_currencies	ON (exc_cur_id = cur_id);